CREATE TABLE ${tableName}
(
   ID NUMBER(38) CONSTRAINT ${tableName}_PK PRIMARY KEY
<#list columnList! as column>
,  ${column.fieldCode} <#if column.fieldType=='string'>VARCHAR2<#elseif column.fieldType=='interget'>NUMBER<#elseif column.fieldType=='long'>NUMBER
<#elseif column.fieldType=='date'>DDATE</#if><#if column.fieldLength??>(${column.fieldLength})<#else>(225)</#if><#if column.defaultValue??> DEFAULT ${column.defaultValue}</#if><#if column.isRequired?? && column.isRequired=='true'> NOT NULL</#if>
</#list>
);
ALTER TABLE ${tableName} ADD CONSTRAINT ${tableName}_ID_UQ UNIQUE (ID);
<#list columnList! as column>
COMMENT ON COLUMN ${tableName}.${column.fieldCode} IS '${column.fieldName}';
</#list>



